package com.report.dto.response;

import cn.zhxu.bs.bean.DbField;
import cn.zhxu.bs.bean.SearchBean;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

import java.io.Serializable;
import java.time.LocalDateTime;

/**
 * @author summer
 * @version 1.0
 * @date 2024/8/1 13:48
 */
@Data
@SearchBean(tables = " report_image i LEFT JOIN research_report r  ON i.report_id=r.id " +
        "LEFT JOIN research_tag t2 ON t2.id=r.industry_id Left JOIN research_file f ON r.file_id=f.id ",autoMapTo = "i",orderBy = "i.createTime DESC")
public class WebReportImageRes implements Serializable {

    @DbField("i.id")
    private Integer id;

    @DbField("i.report_id")
    private Integer reportId;

    @DbField("r.deleted")
    private Integer deleted1;

    @DbField("i.name")
    private String name;

    @DbField("r.name")
    private String reportName;

    @DbField("i.image")
    private String image;

    @DbField("t2.name")
    private String industryName;

    @DbField("r.industry_id")
    private Integer industryId;


    @DbField("i.createTime")
    @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
    private LocalDateTime createTime;

    @DbField("f.image")
    private String fileImage;


}
